2017-25 CAFE Model Input Sheets For Distribution
This folder contains three Excel Worksheets used to create CAFE model inputs for the 2017-2021 CAFE standards and the 2022-2025 augural CAFE standards. The files are:
(1) 2017+_Technology_Costs_2010baseline_ForDistribution.xlsx
(2) 2017+_DecisionTree_2010baseline_ForDistribution.xlsm
(3) 2017+_technologies_2010baseline_ForDistribution.xlsm
These files are internally linked and refer to each other as follows:
	- File (1) feeds into files (2) and (3);
	- File (2) feeds into file (3).
If either of files (1) or (2) are updated, the other files must be opened and the values updated in order to synchronize the files. Note: All files must be open when the values are being updated! Otherwise, the update takes an extraordinarily long time and your computer may freeze.
For internal tracking purposes, the files were originally date/time stamped: 2012_04_27_1030

Brief file descriptions are as follows.
2017+_Technology_Costs_2010baseline_ForDistribution.xlsx
This file contains all technology cost data for each vehicle class and includes various cost-related run parameters, such as dollar year basis, learning factors, use of RPE or ICM, etc.
The costs are split into a "Non-class specific" tab and a tab for each vehicle class. Each of these tabs vertically cascades the costs to show the DMC, IC, Total Cost, and Incremental Cost (in blue). The incremental cost is carried over into the Decision Tree file (2017+_DecisionTree_2010baseline_ForDistribution.xlsm) and final CAFE model input file (2017+_technologies_2010baseline_ForDistribution.xlsm).
Additional tabs describe the mass reduction cost curves, the battery and non-battery costs for PHEVs and EVs as a function of mass reduction, and the learning factor and ICM definitions.

2017+_DecisionTree_2010baseline_ForDistribution.xlsm
This file contains the full, expanded decision trees for all vehicle classes. The decision trees define the baseline vehicle for each class and show the various pathways to add technology incrementally to the vehicle. Also shown are the absolute and incremental cost and effectiveness for each technology. 
Note that the decision trees separate the engine technologies into DOHC, OHC, and OHV paths. Only one of these paths will be applicable to a given vehicle, depending on its initial state.
The incremental effectiveness values for each technology and vehicle class are carried over into the final CAFE model input file (2017+_technologies_2010baseline_ForDistribution.xlsm).

2017+_technologies_2010baseline_ForDistribution.xlsm
This file is used as the input sheet to the CAFE model. It collects the data from the two other input sheets and summarizes it for each vehicle class. The other tabs in this sheet contain the cost and fuel consumption synergy tables.
The input parameter for this sheet determines the type of analysis run, e.g., "EPCA", "EPCA with PHEVs in 2020" (also known as the "standard setting" run), and "With EVs" (also known as the "Real World" run). Currently, the file is set to the "Real World" run.
If a user wishes to run the CAFE model using this sheet, it is suggested to break the links to the other two input sheets and save this file under a new name. To break the links (in Excel 2010), go to the "Data" tab at the top, click "Edit Links", and then break the two file links listed there.